package com.ztesoft.web.baseconfig.db.arg;

import java.util.*;
import java.math.*;
import org.apache.commons.lang.*;

public class DmStrategyArg {
    private String pk_name = "DM_STRATEGY_ID";

    private String orderByClause;

    private String groupByClause;

    private String columns;

    private String countsql1;

    private String countsql2;

    private boolean distinct;

    private int rowStart = 0;

    private int rowEnd = 10;

    private List<DmStrategyCriteria> oredCriteria;

    public DmStrategyArg() {
        oredCriteria = new ArrayList<DmStrategyCriteria>();
    }

    public void setPk_name(String pk_name) {
        this.pk_name = StringEscapeUtils.escapeSql(pk_name);
    }

    public String getPk_name() {
        return pk_name;
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = StringEscapeUtils.escapeSql(orderByClause);
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = StringEscapeUtils.escapeSql(groupByClause);
    }

    public String geGroupByClause() {
        return groupByClause;
    }

    public void setColumns(String columns) {
        this.columns = StringEscapeUtils.escapeSql(columns);
    }

    public String geColumns() {
        return columns;
    }

    public void setCountsql1(String countsql1) {
        this.countsql1 = StringEscapeUtils.escapeSql(countsql1);
    }

    public String geCountsql1() {
        return countsql1;
    }

    public void setCountsql2(String countsql2) {
        this.countsql2 = StringEscapeUtils.escapeSql(countsql2);
    }

    public String geCountsql2() {
        return countsql2;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public void setRowStart(int rowStart) {
        this.rowStart = rowStart;
    }

    public void setRowEnd(int rowEnd) {
        this.rowEnd = rowEnd;
    }

    public int getRowStart() {
        return rowStart;
    }

    public int getRowEnd() {
        return rowEnd;
    }

    public List<DmStrategyCriteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(DmStrategyCriteria criteria) {
        oredCriteria.add(criteria);
    }

    public DmStrategyCriteria or() {
    	DmStrategyCriteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public DmStrategyCriteria createCriteria() {
    	DmStrategyCriteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected DmStrategyCriteria createCriteriaInternal() {
    	DmStrategyCriteria criteria = new DmStrategyCriteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        groupByClause = null;
        columns = null;
        countsql1 = null;
        countsql2 = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<DmStrategyCriterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<DmStrategyCriterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<DmStrategyCriterion> getAllCriteria() {
            return criteria;
        }

        public List<DmStrategyCriterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new DmStrategyCriterion(condition));
        }

        protected void addCriterion(String condition, Object value,
                String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new DmStrategyCriterion(condition, value));
        }

        protected void addCriterion(String condition, Object value,
                String property, int likeType) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new DmStrategyCriterion(condition, value, likeType));
        }

        protected void addCriterion(String condition, Object value1,
                Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property
                        + " cannot be null");
            }
            criteria.add(new DmStrategyCriterion(condition, value1, value2));
        }

        public DmStrategyCriteria andCriterionEqualTo(String criterion) {
            if (StringUtils.isBlank(criterion)) {
                criterion = "1=1";
            }
            addCriterion(criterion);
            return (DmStrategyCriteria) this;
        }
        public DmStrategyCriteria andDmStrategyIdIsNull() {
            addCriterion("DM_STRATEGY_ID is null");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andDmStrategyIdIsNotNull() {
            addCriterion("DM_STRATEGY_ID is not null");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andDmStrategyIdEqualTo(Integer value) {
            addCriterion("DM_STRATEGY_ID =", value, "DM_STRATEGY_ID");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andDmStrategyIdNotEqualTo(Integer value) {
            addCriterion("DM_STRATEGY_ID <>", value, "DM_STRATEGY_ID");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andDmStrategyIdGreaterThan(Integer value) {
            addCriterion("DM_STRATEGY_ID >", value, "DM_STRATEGY_ID");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andDmStrategyIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("DM_STRATEGY_ID >=", value, "DM_STRATEGY_ID");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andDmStrategyIdLessThan(Integer value) {
            addCriterion("DM_STRATEGY_ID <", value, "DM_STRATEGY_ID");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andDmStrategyIdLessThanOrEqualTo(Integer value) {
            addCriterion("DM_STRATEGY_ID <=", value, "DM_STRATEGY_ID");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andDmStrategyIdLike(Integer value) {
            addCriterion("DM_STRATEGY_ID like ", value, "DM_STRATEGY_ID", 1);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andDmStrategyIdNotLike(Integer value) {
            addCriterion("DM_STRATEGY_ID  not like ", value, "DM_STRATEGY_ID", 1);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andDmStrategyIdLeftLike(Integer value) {
            addCriterion("DM_STRATEGY_ID like ", value, "DM_STRATEGY_ID", 0);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andDmStrategyIdNotLeftLike(Integer value) {
            addCriterion("DM_STRATEGY_ID  not like ", value, "DM_STRATEGY_ID", 0);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andDmStrategyIdRightLike(Integer value) {
            addCriterion("DM_STRATEGY_ID like ", value, "DM_STRATEGY_ID", 2);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andDmStrategyIdNotRightLike(Integer value) {
            addCriterion("DM_STRATEGY_ID  not like ", value, "DM_STRATEGY_ID", 2);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andDmStrategyIdIn(List<Integer> values) {
            addCriterion("DM_STRATEGY_ID  in ", values, "DM_STRATEGY_ID");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andDmStrategyIdNotIn(List<Integer> values) {
            addCriterion("DM_STRATEGY_ID not in ", values, "DM_STRATEGY_ID");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andDmStrategyIdBetween(Integer value1, Integer value2) {
            addCriterion("DM_STRATEGY_ID between ", value1, value2, "DM_STRATEGY_ID");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andDmStrategyIdNotBetween(Integer value1, Integer value2) {
            addCriterion("DM_STRATEGY_ID not between ", value1, value2, "DM_STRATEGY_ID");
            return (DmStrategyCriteria) this;
        }
        public DmStrategyCriteria andSeqNbrIsNull() {
            addCriterion("SEQ_NBR is null");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andSeqNbrIsNotNull() {
            addCriterion("SEQ_NBR is not null");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andSeqNbrEqualTo(Integer value) {
            addCriterion("SEQ_NBR =", value, "SEQ_NBR");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andSeqNbrNotEqualTo(Integer value) {
            addCriterion("SEQ_NBR <>", value, "SEQ_NBR");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andSeqNbrGreaterThan(Integer value) {
            addCriterion("SEQ_NBR >", value, "SEQ_NBR");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andSeqNbrGreaterThanOrEqualTo(Integer value) {
            addCriterion("SEQ_NBR >=", value, "SEQ_NBR");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andSeqNbrLessThan(Integer value) {
            addCriterion("SEQ_NBR <", value, "SEQ_NBR");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andSeqNbrLessThanOrEqualTo(Integer value) {
            addCriterion("SEQ_NBR <=", value, "SEQ_NBR");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andSeqNbrLike(Integer value) {
            addCriterion("SEQ_NBR like ", value, "SEQ_NBR", 1);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andSeqNbrNotLike(Integer value) {
            addCriterion("SEQ_NBR  not like ", value, "SEQ_NBR", 1);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andSeqNbrLeftLike(Integer value) {
            addCriterion("SEQ_NBR like ", value, "SEQ_NBR", 0);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andSeqNbrNotLeftLike(Integer value) {
            addCriterion("SEQ_NBR  not like ", value, "SEQ_NBR", 0);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andSeqNbrRightLike(Integer value) {
            addCriterion("SEQ_NBR like ", value, "SEQ_NBR", 2);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andSeqNbrNotRightLike(Integer value) {
            addCriterion("SEQ_NBR  not like ", value, "SEQ_NBR", 2);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andSeqNbrIn(List<Integer> values) {
            addCriterion("SEQ_NBR  in ", values, "SEQ_NBR");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andSeqNbrNotIn(List<Integer> values) {
            addCriterion("SEQ_NBR not in ", values, "SEQ_NBR");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andSeqNbrBetween(Integer value1, Integer value2) {
            addCriterion("SEQ_NBR between ", value1, value2, "SEQ_NBR");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andSeqNbrNotBetween(Integer value1, Integer value2) {
            addCriterion("SEQ_NBR not between ", value1, value2, "SEQ_NBR");
            return (DmStrategyCriteria) this;
        }
        public DmStrategyCriteria andStrategyNameIsNull() {
            addCriterion("STRATEGY_NAME is null");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStrategyNameIsNotNull() {
            addCriterion("STRATEGY_NAME is not null");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStrategyNameEqualTo(String value) {
            addCriterion("STRATEGY_NAME =", value, "STRATEGY_NAME");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStrategyNameNotEqualTo(String value) {
            addCriterion("STRATEGY_NAME <>", value, "STRATEGY_NAME");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStrategyNameGreaterThan(String value) {
            addCriterion("STRATEGY_NAME >", value, "STRATEGY_NAME");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStrategyNameGreaterThanOrEqualTo(String value) {
            addCriterion("STRATEGY_NAME >=", value, "STRATEGY_NAME");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStrategyNameLessThan(String value) {
            addCriterion("STRATEGY_NAME <", value, "STRATEGY_NAME");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStrategyNameLessThanOrEqualTo(String value) {
            addCriterion("STRATEGY_NAME <=", value, "STRATEGY_NAME");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStrategyNameLike(String value) {
            addCriterion("STRATEGY_NAME like ", value, "STRATEGY_NAME", 1);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStrategyNameNotLike(String value) {
            addCriterion("STRATEGY_NAME  not like ", value, "STRATEGY_NAME", 1);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStrategyNameLeftLike(String value) {
            addCriterion("STRATEGY_NAME like ", value, "STRATEGY_NAME", 0);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStrategyNameNotLeftLike(String value) {
            addCriterion("STRATEGY_NAME  not like ", value, "STRATEGY_NAME", 0);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStrategyNameRightLike(String value) {
            addCriterion("STRATEGY_NAME like ", value, "STRATEGY_NAME", 2);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStrategyNameNotRightLike(String value) {
            addCriterion("STRATEGY_NAME  not like ", value, "STRATEGY_NAME", 2);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStrategyNameIn(List<String> values) {
            addCriterion("STRATEGY_NAME  in ", values, "STRATEGY_NAME");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStrategyNameNotIn(List<String> values) {
            addCriterion("STRATEGY_NAME not in ", values, "STRATEGY_NAME");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStrategyNameBetween(String value1, String value2) {
            addCriterion("STRATEGY_NAME between ", value1, value2, "STRATEGY_NAME");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStrategyNameNotBetween(String value1, String value2) {
            addCriterion("STRATEGY_NAME not between ", value1, value2, "STRATEGY_NAME");
            return (DmStrategyCriteria) this;
        }
        public DmStrategyCriteria andHotDataFlagIsNull() {
            addCriterion("HOT_DATA_FLAG is null");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andHotDataFlagIsNotNull() {
            addCriterion("HOT_DATA_FLAG is not null");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andHotDataFlagEqualTo(Integer value) {
            addCriterion("HOT_DATA_FLAG =", value, "HOT_DATA_FLAG");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andHotDataFlagNotEqualTo(Integer value) {
            addCriterion("HOT_DATA_FLAG <>", value, "HOT_DATA_FLAG");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andHotDataFlagGreaterThan(Integer value) {
            addCriterion("HOT_DATA_FLAG >", value, "HOT_DATA_FLAG");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andHotDataFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("HOT_DATA_FLAG >=", value, "HOT_DATA_FLAG");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andHotDataFlagLessThan(Integer value) {
            addCriterion("HOT_DATA_FLAG <", value, "HOT_DATA_FLAG");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andHotDataFlagLessThanOrEqualTo(Integer value) {
            addCriterion("HOT_DATA_FLAG <=", value, "HOT_DATA_FLAG");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andHotDataFlagLike(Integer value) {
            addCriterion("HOT_DATA_FLAG like ", value, "HOT_DATA_FLAG", 1);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andHotDataFlagNotLike(Integer value) {
            addCriterion("HOT_DATA_FLAG  not like ", value, "HOT_DATA_FLAG", 1);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andHotDataFlagLeftLike(Integer value) {
            addCriterion("HOT_DATA_FLAG like ", value, "HOT_DATA_FLAG", 0);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andHotDataFlagNotLeftLike(Integer value) {
            addCriterion("HOT_DATA_FLAG  not like ", value, "HOT_DATA_FLAG", 0);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andHotDataFlagRightLike(Integer value) {
            addCriterion("HOT_DATA_FLAG like ", value, "HOT_DATA_FLAG", 2);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andHotDataFlagNotRightLike(Integer value) {
            addCriterion("HOT_DATA_FLAG  not like ", value, "HOT_DATA_FLAG", 2);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andHotDataFlagIn(List<Integer> values) {
            addCriterion("HOT_DATA_FLAG  in ", values, "HOT_DATA_FLAG");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andHotDataFlagNotIn(List<Integer> values) {
            addCriterion("HOT_DATA_FLAG not in ", values, "HOT_DATA_FLAG");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andHotDataFlagBetween(Integer value1, Integer value2) {
            addCriterion("HOT_DATA_FLAG between ", value1, value2, "HOT_DATA_FLAG");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andHotDataFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("HOT_DATA_FLAG not between ", value1, value2, "HOT_DATA_FLAG");
            return (DmStrategyCriteria) this;
        }
        public DmStrategyCriteria andConcurrentNumberIsNull() {
            addCriterion("CONCURRENT_NUMBER is null");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andConcurrentNumberIsNotNull() {
            addCriterion("CONCURRENT_NUMBER is not null");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andConcurrentNumberEqualTo(Integer value) {
            addCriterion("CONCURRENT_NUMBER =", value, "CONCURRENT_NUMBER");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andConcurrentNumberNotEqualTo(Integer value) {
            addCriterion("CONCURRENT_NUMBER <>", value, "CONCURRENT_NUMBER");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andConcurrentNumberGreaterThan(Integer value) {
            addCriterion("CONCURRENT_NUMBER >", value, "CONCURRENT_NUMBER");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andConcurrentNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("CONCURRENT_NUMBER >=", value, "CONCURRENT_NUMBER");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andConcurrentNumberLessThan(Integer value) {
            addCriterion("CONCURRENT_NUMBER <", value, "CONCURRENT_NUMBER");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andConcurrentNumberLessThanOrEqualTo(Integer value) {
            addCriterion("CONCURRENT_NUMBER <=", value, "CONCURRENT_NUMBER");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andConcurrentNumberLike(Integer value) {
            addCriterion("CONCURRENT_NUMBER like ", value, "CONCURRENT_NUMBER", 1);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andConcurrentNumberNotLike(Integer value) {
            addCriterion("CONCURRENT_NUMBER  not like ", value, "CONCURRENT_NUMBER", 1);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andConcurrentNumberLeftLike(Integer value) {
            addCriterion("CONCURRENT_NUMBER like ", value, "CONCURRENT_NUMBER", 0);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andConcurrentNumberNotLeftLike(Integer value) {
            addCriterion("CONCURRENT_NUMBER  not like ", value, "CONCURRENT_NUMBER", 0);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andConcurrentNumberRightLike(Integer value) {
            addCriterion("CONCURRENT_NUMBER like ", value, "CONCURRENT_NUMBER", 2);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andConcurrentNumberNotRightLike(Integer value) {
            addCriterion("CONCURRENT_NUMBER  not like ", value, "CONCURRENT_NUMBER", 2);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andConcurrentNumberIn(List<Integer> values) {
            addCriterion("CONCURRENT_NUMBER  in ", values, "CONCURRENT_NUMBER");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andConcurrentNumberNotIn(List<Integer> values) {
            addCriterion("CONCURRENT_NUMBER not in ", values, "CONCURRENT_NUMBER");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andConcurrentNumberBetween(Integer value1, Integer value2) {
            addCriterion("CONCURRENT_NUMBER between ", value1, value2, "CONCURRENT_NUMBER");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andConcurrentNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("CONCURRENT_NUMBER not between ", value1, value2, "CONCURRENT_NUMBER");
            return (DmStrategyCriteria) this;
        }
        public DmStrategyCriteria andUpperCntIsNull() {
            addCriterion("UPPER_CNT is null");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andUpperCntIsNotNull() {
            addCriterion("UPPER_CNT is not null");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andUpperCntEqualTo(Integer value) {
            addCriterion("UPPER_CNT =", value, "UPPER_CNT");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andUpperCntNotEqualTo(Integer value) {
            addCriterion("UPPER_CNT <>", value, "UPPER_CNT");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andUpperCntGreaterThan(Integer value) {
            addCriterion("UPPER_CNT >", value, "UPPER_CNT");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andUpperCntGreaterThanOrEqualTo(Integer value) {
            addCriterion("UPPER_CNT >=", value, "UPPER_CNT");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andUpperCntLessThan(Integer value) {
            addCriterion("UPPER_CNT <", value, "UPPER_CNT");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andUpperCntLessThanOrEqualTo(Integer value) {
            addCriterion("UPPER_CNT <=", value, "UPPER_CNT");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andUpperCntLike(Integer value) {
            addCriterion("UPPER_CNT like ", value, "UPPER_CNT", 1);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andUpperCntNotLike(Integer value) {
            addCriterion("UPPER_CNT  not like ", value, "UPPER_CNT", 1);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andUpperCntLeftLike(Integer value) {
            addCriterion("UPPER_CNT like ", value, "UPPER_CNT", 0);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andUpperCntNotLeftLike(Integer value) {
            addCriterion("UPPER_CNT  not like ", value, "UPPER_CNT", 0);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andUpperCntRightLike(Integer value) {
            addCriterion("UPPER_CNT like ", value, "UPPER_CNT", 2);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andUpperCntNotRightLike(Integer value) {
            addCriterion("UPPER_CNT  not like ", value, "UPPER_CNT", 2);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andUpperCntIn(List<Integer> values) {
            addCriterion("UPPER_CNT  in ", values, "UPPER_CNT");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andUpperCntNotIn(List<Integer> values) {
            addCriterion("UPPER_CNT not in ", values, "UPPER_CNT");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andUpperCntBetween(Integer value1, Integer value2) {
            addCriterion("UPPER_CNT between ", value1, value2, "UPPER_CNT");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andUpperCntNotBetween(Integer value1, Integer value2) {
            addCriterion("UPPER_CNT not between ", value1, value2, "UPPER_CNT");
            return (DmStrategyCriteria) this;
        }
        public DmStrategyCriteria andStateIsNull() {
            addCriterion("STATE is null");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateIsNotNull() {
            addCriterion("STATE is not null");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateEqualTo(String value) {
            addCriterion("STATE =", value, "STATE");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateNotEqualTo(String value) {
            addCriterion("STATE <>", value, "STATE");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateGreaterThan(String value) {
            addCriterion("STATE >", value, "STATE");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE >=", value, "STATE");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateLessThan(String value) {
            addCriterion("STATE <", value, "STATE");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateLessThanOrEqualTo(String value) {
            addCriterion("STATE <=", value, "STATE");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateLike(String value) {
            addCriterion("STATE like ", value, "STATE", 1);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateNotLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 1);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateLeftLike(String value) {
            addCriterion("STATE like ", value, "STATE", 0);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateNotLeftLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 0);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateRightLike(String value) {
            addCriterion("STATE like ", value, "STATE", 2);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateNotRightLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 2);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateIn(List<String> values) {
            addCriterion("STATE  in ", values, "STATE");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateNotIn(List<String> values) {
            addCriterion("STATE not in ", values, "STATE");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateBetween(String value1, String value2) {
            addCriterion("STATE between ", value1, value2, "STATE");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateNotBetween(String value1, String value2) {
            addCriterion("STATE not between ", value1, value2, "STATE");
            return (DmStrategyCriteria) this;
        }
        public DmStrategyCriteria andStateDateIsNull() {
            addCriterion("STATE_DATE is null");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateDateIsNotNull() {
            addCriterion("STATE_DATE is not null");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateDateEqualTo(String value) {
            addCriterion("STATE_DATE =", value, "STATE_DATE");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateDateNotEqualTo(String value) {
            addCriterion("STATE_DATE <>", value, "STATE_DATE");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateDateGreaterThan(String value) {
            addCriterion("STATE_DATE >", value, "STATE_DATE");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateDateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE_DATE >=", value, "STATE_DATE");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateDateLessThan(String value) {
            addCriterion("STATE_DATE <", value, "STATE_DATE");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateDateLessThanOrEqualTo(String value) {
            addCriterion("STATE_DATE <=", value, "STATE_DATE");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateDateLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 1);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateDateNotLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 1);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateDateLeftLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 0);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateDateNotLeftLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 0);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateDateRightLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 2);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateDateNotRightLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 2);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateDateIn(List<String> values) {
            addCriterion("STATE_DATE  in ", values, "STATE_DATE");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateDateNotIn(List<String> values) {
            addCriterion("STATE_DATE not in ", values, "STATE_DATE");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateDateBetween(String value1, String value2) {
            addCriterion("STATE_DATE between ", value1, value2, "STATE_DATE");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStateDateNotBetween(String value1, String value2) {
            addCriterion("STATE_DATE not between ", value1, value2, "STATE_DATE");
            return (DmStrategyCriteria) this;
        }
        public DmStrategyCriteria andStaffIdIsNull() {
            addCriterion("STAFF_ID is null");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStaffIdIsNotNull() {
            addCriterion("STAFF_ID is not null");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStaffIdEqualTo(Integer value) {
            addCriterion("STAFF_ID =", value, "STAFF_ID");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStaffIdNotEqualTo(Integer value) {
            addCriterion("STAFF_ID <>", value, "STAFF_ID");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStaffIdGreaterThan(Integer value) {
            addCriterion("STAFF_ID >", value, "STAFF_ID");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStaffIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("STAFF_ID >=", value, "STAFF_ID");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStaffIdLessThan(Integer value) {
            addCriterion("STAFF_ID <", value, "STAFF_ID");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStaffIdLessThanOrEqualTo(Integer value) {
            addCriterion("STAFF_ID <=", value, "STAFF_ID");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStaffIdLike(Integer value) {
            addCriterion("STAFF_ID like ", value, "STAFF_ID", 1);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStaffIdNotLike(Integer value) {
            addCriterion("STAFF_ID  not like ", value, "STAFF_ID", 1);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStaffIdLeftLike(Integer value) {
            addCriterion("STAFF_ID like ", value, "STAFF_ID", 0);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStaffIdNotLeftLike(Integer value) {
            addCriterion("STAFF_ID  not like ", value, "STAFF_ID", 0);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStaffIdRightLike(Integer value) {
            addCriterion("STAFF_ID like ", value, "STAFF_ID", 2);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStaffIdNotRightLike(Integer value) {
            addCriterion("STAFF_ID  not like ", value, "STAFF_ID", 2);
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStaffIdIn(List<Integer> values) {
            addCriterion("STAFF_ID  in ", values, "STAFF_ID");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStaffIdNotIn(List<Integer> values) {
            addCriterion("STAFF_ID not in ", values, "STAFF_ID");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStaffIdBetween(Integer value1, Integer value2) {
            addCriterion("STAFF_ID between ", value1, value2, "STAFF_ID");
            return (DmStrategyCriteria) this;
        }

        public DmStrategyCriteria andStaffIdNotBetween(Integer value1, Integer value2) {
            addCriterion("STAFF_ID not between ", value1, value2, "STAFF_ID");
            return (DmStrategyCriteria) this;
        }

    }

    public static class DmStrategyCriteria extends GeneratedCriteria {

        protected DmStrategyCriteria() {
            super();
        }
    }

    public static class DmStrategyCriterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected DmStrategyCriterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }
        protected DmStrategyCriterion(String condition, Object value, int likeType) {
            this.condition = condition;
            if (likeType == 0) {
                this.value = "%" + value;
            }
            else if (likeType == 1) {
                this.value = "%" + value + "%";
            }
            else {
                this.value = value + "%";
            }
            this.typeHandler = null;
            this.singleValue = true;

        }

        protected DmStrategyCriterion(String condition, Object value,
                String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            }
            else {
                this.singleValue = true;
            }
        }

        protected DmStrategyCriterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected DmStrategyCriterion(String condition, Object value,
                Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected DmStrategyCriterion(String condition, Object value,
                Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}